// sql语句
//sqlMap.js——SQL 语句映射文件，供 API 调用
var sqlMap = {
    diagnosis: {
        add: 'INSERT INTO diagnosislist(id,name,idCardNo,sex,address,phoneNumber,myDesc,source) VALUES(0,?,?,?,?,?,?,?)',
        update: 'UPDATE diagnosislist SET name = ?,idCardNo = ?,sex = ?,address = ?,phoneNumber = ?,myDesc = ?,source = ? WHERE id = ?',
        delete: 'DELETE FROM diagnosislist where id = ?'
    },
    suspected:{
        add: 'INSERT INTO suspectedlist(id,name,idCardNo,sex,address,phoneNumber,myDesc,source) VALUES(0,?,?,?,?,?,?,?)',
        update: 'UPDATE suspectedlist SET name = ?,idCardNo = ?,sex = ?,address = ?,phoneNumber = ?,myDesc = ?,source = ? WHERE id = ?',
        delete: 'DELETE FROM suspectedlist where id = ?'
    },
    user:{
        add: 'INSERT INTO userlist(userId,userName,userPassword,userRealName,roleName,userMobile,userEmail) VALUES(0,?,?,?,?,?,?)',
        update: 'UPDATE userlist SET userName = ?,userPassword = ?,userRealName = ?,roleName = ?,userMobile = ?,userEmail = ? WHERE userId = ?',
        delete: 'DELETE FROM userlist where userId = ?'
    },
}
module.exports = sqlMap


